-- Write your migrate up statements here
CREATE TABLE IF NOT EXISTS user_google (
	email VARCHAR NOT NULL PRIMARY KEY,
    family_name VARCHAR NOT NULL,
    given_name VARCHAR NOT NULL,
    nik VARCHAR NOT NULL,
    locale VARCHAR,
    full_name VARCHAR,
    picture VARCHAR DEFAULT 'qwerty',
    verified_email BOOLEAN NOT NULL
);
CREATE TABLE IF NOT EXISTS favorite (
    favorite_id uuid DEFAULT gen_random_uuid(),
    user_id VARCHAR REFERENCES user_google (email),
    title VARCHAR NOT NULL,
    url VARCHAR NOT NULL,
    PRIMARY KEY (favorite_id)
);
---- create above / drop below ----
drop table favorite;
drop table user_google;

-- Write your migrate down statements here. If this migration is irreversible
-- Then delete the separator line above.
